CREATE TABLE register(
	id int(11) not null PRIMARY KEY AUTO_INCREMENT,
    fullnames varchar(255) not null,
     emails varchar(255) not null,
     countrys varchar(255) not null,
     addrs varchar(255) not null,
     phones varchar(255) not null,
    
     fullnamer varchar(255) not null,
     emailr varchar(255) not null,
     countryr varchar(255) not null,
     addrr varchar(255) not null,
     phoner varchar(255) not null,
	stater varchar(255) not null,
	cityr varchar(255) not null,
	zip varchar(255) not null,
    
    
    
     trackingcode varchar(255) not null,
     expecteddate varchar(255) not null,
     datesent varchar(255) not null,
     amount varchar(255) not null,
     parceldescrip varchar(255) not null,
     statusparcel varchar(255) not null,
     currentlocat varchar(255) not null,
	weight varchar(255) not null,
	comment varchar(255) not null

);


CREATE TABLE admin(
	id int(11) not null PRIMARY KEY AUTO_INCREMENT,
    usd varchar(255) not null,
     pwd varchar(255) not null

);



INSERT INTO admin (usd,pwd) VALUES ('admin','admin');



CREATE TABLE history(
	id int(11) not null PRIMARY KEY AUTO_INCREMENT,
    trackingcode varchar(255) not null,
	lastlocation varchar(255) not null,
	status varchar(255) not null,
	date varchar(255) not null,
     remark varchar(500) not null

);

